"C:\Program Files (x86)\Microsoft Visual Studio\Shared\Python37_64\python.exe" C:/Users/52334/PycharmProjects/sql_work/main.py
<table class="print" width="100%">
<tr>
<th width="50">字段</th>
<th width="80">类型</th>
<th width="40">空</th>
<th width="70">默认</th>
<th>注释</th>
</tr>
<tr class="odd">
<td class="nowrap">id <em>(主键)</em></td>
<td class="nowrap" dir="ltr" lang="en">varchar(64)</td>
<td>否</td>
<td class="nowrap"></td>
<td>文章编号</td>
</tr>
<tr class="even">
<td class="nowrap">catId</td>
<td class="nowrap" dir="ltr" lang="en">varchar(64)</td>
<td>否</td>
<td class="nowrap">0</td>
<td>分类编号</td>
</tr>
<tr class="odd">
<td class="nowrap">userId</td>
<td class="nowrap" dir="ltr" lang="en">varchar(64)</td>
<td>否</td>
<td class="nowrap">0</td>
<td>用户编号</td>
</tr>
<tr class="even">
<td class="nowrap">userName</td>
<td class="nowrap" dir="ltr" lang="en">varchar(255)</td>
<td>是</td>
<td class="nowrap"><i>NULL</i></td>
<td>用户名</td>
</tr>
<tr class="odd">
<td class="nowrap">title</td>
<td class="nowrap" dir="ltr" lang="en">varchar(255)</td>
<td>是</td>
<td class="nowrap"><i>NULL</i></td>
<td>标题</td>
</tr>
<tr class="even">
<td class="nowrap">author</td>
<td class="nowrap" dir="ltr" lang="en">varchar(32)</td>
<td>是</td>
<td class="nowrap"><i>NULL</i></td>
<td>作者</td>
</tr>
<tr class="odd">
<td class="nowrap">from</td>
<td class="nowrap" dir="ltr" lang="en">varchar(255)</td>
<td>是</td>
<td class="nowrap"><i>NULL</i></td>
<td>来源</td>
</tr>
<tr class="even">
<td class="nowrap">fromurl</td>
<td class="nowrap" dir="ltr" lang="en">varchar(255)</td>
<td>是</td>
<td class="nowrap"><i>NULL</i></td>
<td>来源地址</td>
</tr>
<tr class="odd">
<td class="nowrap">url</td>
<td class="nowrap" dir="ltr" lang="en">varchar(255)</td>
<td>是</td>
<td class="nowrap"><i>NULL</i></td>
<td>文章地址</td>
</tr>
<tr class="even">
<td class="nowrap">summary</td>
<td class="nowrap" dir="ltr" lang="en">varchar(255)</td>
<td>是</td>
<td class="nowrap"><i>NULL</i></td>
<td>简介</td>
</tr>
<tr class="odd">
<td class="nowrap">pic</td>
<td class="nowrap" dir="ltr" lang="en">varchar(255)</td>
<td>是</td>
<td class="nowrap"><i>NULL</i></td>
<td>新闻列表图片</td>
</tr>
<tr class="even">
<td class="nowrap">content</td>
<td class="nowrap" dir="ltr" lang="en">mediumtext</td>
<td>是</td>
<td class="nowrap"><i>NULL</i></td>
<td>文字内容</td>
</tr>
<tr class="odd">
<td class="nowrap">viewTimes</td>
<td class="nowrap" dir="ltr" lang="en">int(11)</td>
<td>是</td>
<td class="nowrap">0</td>
<td>文章阅读浏览次数</td>
</tr>
<tr class="even">
<td class="nowrap">seotitle</td>
<td class="nowrap" dir="ltr" lang="en">varchar(255)</td>
<td>是</td>
<td class="nowrap"><i>NULL</i></td>
<td>SEO标题</td>
</tr>
<tr class="odd">
<td class="nowrap">keywords</td>
<td class="nowrap" dir="ltr" lang="en">varchar(255)</td>
<td>是</td>
<td class="nowrap"><i>NULL</i></td>
<td>SEO关键词</td>
</tr>
<tr class="even">
<td class="nowrap">description</td>
<td class="nowrap" dir="ltr" lang="en">varchar(255)</td>
<td>是</td>
<td class="nowrap"><i>NULL</i></td>
<td>SEO描述</td>
</tr>
<tr class="odd">
<td class="nowrap">displayOrder</td>
<td class="nowrap" dir="ltr" lang="en">int(11)</td>
<td>是</td>
<td class="nowrap"><i>NULL</i></td>
<td>排序</td>
</tr>
<tr class="even">
<td class="nowrap">remarks</td>
<td class="nowrap" dir="ltr" lang="en">tinytext</td>
<td>是</td>
<td class="nowrap"><i>NULL</i></td>
<td>备注</td>
</tr>
<tr class="odd">
<td class="nowrap">createdate</td>
<td class="nowrap" dir="ltr" lang="en">datetime</td>
<td>是</td>
<td class="nowrap"><i>NULL</i></td>
<td>创建时间</td>
</tr>
<tr class="even">
<td class="nowrap">updatedate</td>
<td class="nowrap" dir="ltr" lang="en">datetime</td>
<td>是</td>
<td class="nowrap"><i>NULL</i></td>
<td>修改时间</td>
</tr>
<tr class="odd">
<td class="nowrap">delFlag</td>
<td class="nowrap" dir="ltr" lang="en">tinyint(1)</td>
<td>是</td>
<td class="nowrap">0</td>
<td>是否标记删除</td>
</tr>
<tr class="even">
<td class="nowrap">isTop</td>
<td class="nowrap" dir="ltr" lang="en">tinyint(1)</td>
<td>是</td>
<td class="nowrap">0</td>
<td>是否置顶</td>
</tr>
<tr class="odd">
<td class="nowrap">topDate</td>
<td class="nowrap" dir="ltr" lang="en">datetime</td>
<td>是</td>
<td class="nowrap"><i>NULL</i></td>
<td>置顶时间</td>
</tr>
<tr class="even">
<td class="nowrap">articleType</td>
<td class="nowrap" dir="ltr" lang="en">tinyint(4)</td>
<td>是</td>
<td class="nowrap"><i>NULL</i></td>
<td>类型：1.资讯2.学习中心3.常见问题4.交易规则</td>
</tr>
<tr class="odd">
<td class="nowrap">status</td>
<td class="nowrap" dir="ltr" lang="en">tinyint(4)</td>
<td>否</td>
<td class="nowrap">1</td>
<td>状态</td>
</tr>
<tr class="even">
<td class="nowrap">videoUrl</td>
<td class="nowrap" dir="ltr" lang="en">varchar(255)</td>
<td>是</td>
<td class="nowrap"><i>NULL</i></td>
<td></td>
</tr>
</table>